<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"> <style>
	.KEYW {color: #933;}
	.COMM {color: #bbb; font-style: italic;}
	.NUMB {color: #393;}
	.STRN {color: #393;}
	.REGX {color: #339;}
	.line {border-right: 1px dotted #666; color: #666; font-style: normal;}
	</style></head><body><pre><span class='line'>  1</span> <span class="KEYW">var</span><span class="WHIT"> </span><span class="NAME">agr</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="NAME">agr</span><span class="WHIT"> </span><span class="PUNC">||</span><span class="WHIT"> </span><span class="PUNC">{</span><span class="PUNC">}</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>  2</span> 
<span class='line'>  3</span> </span><span class="NAME">agr.sql</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="NAME">agr.sql</span><span class="WHIT"> </span><span class="PUNC">||</span><span class="WHIT"> </span><span class="PUNC">{</span><span class="PUNC">}</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>  4</span> 
<span class='line'>  5</span> </span><span class="NAME">agr.sql.init</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="PUNC">[</span><span class="PUNC">]</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>  6</span> 
<span class='line'>  7</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'CREATE TABLE Colony ( 	ID INTEGER PRIMARY KEY, 	Created DATETIME DEFAULT CURRENT_TIMESTAMP, 	Modified DATETIME DEFAULT CURRENT_TIMESTAMP, 	Name TEXT UNIQUE NOT NULL,     GenderDefault TEXT NOT NULL,     CHECK(case GenderDefault when "M" then 1 when "F" then 1 when "N" then 1 else 0 end));'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>  8</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Colony" VALUES(1,"2012-03-11 23:47:26","2012-03-11 23:47:26","EPO","N");'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>  9</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'CREATE TABLE Genotype (  	ID INTEGER PRIMARY KEY, 	ColonyID INTEGER NOT NULL REFERENCES Colony(ID), 	Created DATETIME DEFAULT CURRENT_TIMESTAMP, 	Modified DATETIME DEFAULT CURRENT_TIMESTAMP, 	Name VARCHAR NOT NULL,  	UNIQUE(ColonyID, Name)  );'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 10</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Genotype" VALUES(1,1,"2012-03-11 23:47:26","2012-03-11 23:47:26","Epo fl/fl");'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 11</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Genotype" VALUES(2,1,"2012-03-11 23:47:26","2012-03-11 23:47:26","C57BL");'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 12</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'CREATE TABLE Mouse ( 	ID INTEGER PRIMARY KEY, 	ColonyID INTEGER NOT NULL REFERENCES Colony(ID), 	Created DATETIME DEFAULT CURRENT_TIMESTAMP, 	Modified DATETIME DEFAULT CURRENT_TIMESTAMP, 	DateOfBirth DATE NOT NULL DEFAULT CURRENT_DATE, 	Disabled BOOLEAN DEFAULT 0, 	Gender TEXT, 	GenotypeID INTEGER REFERENCES Genotype(ID),     Cage TEXT, 	Tag TEXT );'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 13</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(1,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2011-11-18",0,"F",1,NULL,"027");'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 14</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(2,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2011-11-18",0,"F",1,NULL,"720");'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 15</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(3,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2011-11-18",0,"F",1,NULL,"193");'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 16</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(4,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2011-11-18",0,"F",1,NULL,"222");'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 17</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(5,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2011-12-23",0,"F",1,NULL,"865");'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 18</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(6,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2011-12-23",0,"M",1,NULL,"466");'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 19</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(7,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2011-12-23",0,"M",1,NULL,"862");'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 20</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(8,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2011-12-23",0,"M",1,NULL,"118");'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 21</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(9,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2011-12-23",0,"M",1,NULL,"692");'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 22</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(10,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2011-11-30",0,"M",1,NULL,"921");'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 23</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(11,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2011-11-30",0,"M",1,NULL,"271");'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 24</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(12,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2011-11-30",0,"F",1,NULL,"441");'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 25</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(13,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2011-11-30",0,"F",1,NULL,"537");'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 26</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(14,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2011-12-28",0,"F",1,NULL,"728");'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 27</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(15,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2011-12-28",0,"F",1,NULL,"176");'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 28</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(16,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2011-12-28",0,"F",1,NULL,"367");'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 29</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(17,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2011-12-28",0,"F",1,NULL,"390");'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 30</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(18,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2011-12-28",0,"M",1,NULL,"951");'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 31</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(19,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2011-12-28",0,"M",1,NULL,"220");'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 32</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(20,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2011-12-28",0,"M",1,NULL,"055");'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 33</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(21,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2011-11-19",0,"M",1,NULL,"809");'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 34</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(22,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2011-11-19",0,"M",1,NULL,"643");'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 35</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(23,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2011-11-19",0,"M",1,NULL,"034");'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 36</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(24,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2011-11-19",0,"M",1,NULL,"374");'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 37</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(25,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2011-12-29",0,"F",1,NULL,"768");'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 38</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(26,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2011-12-29",0,"F",1,NULL,"545");'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 39</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(27,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2011-12-29",0,"M",1,NULL,"120");'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 40</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(28,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2011-12-29",0,"M",1,NULL,"246");'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 41</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(29,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2011-12-29",0,"M",1,NULL,"562");'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 42</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(30,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-02-19",0,"F",1,NULL,NULL);'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 43</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(31,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-02-19",0,"F",1,NULL,NULL);'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 44</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(32,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-02-19",0,"F",1,NULL,NULL);'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 45</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(33,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-02-19",0,"F",1,NULL,NULL);'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 46</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(34,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-02-19",0,"M",1,NULL,NULL);'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 47</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(35,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-02-19",0,"M",1,NULL,NULL);'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 48</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(36,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-02-19",0,"M",1,NULL,NULL);'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 49</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(37,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-02-19",0,"M",1,NULL,NULL);'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 50</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(38,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-02-19",0,"M",1,NULL,NULL);'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 51</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(39,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-03-09",0,"",1,NULL,NULL);'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 52</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(40,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-03-09",0,"",1,NULL,NULL);'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 53</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(41,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-03-09",0,"",1,NULL,NULL);'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 54</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(42,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-03-09",0,"",1,NULL,NULL);'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 55</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(43,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-01-17",0,"F",2,NULL,"737");'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 56</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(44,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-01-17",0,"F",2,NULL,"692");'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 57</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(45,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-01-17",0,"F",2,NULL,"175");'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 58</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(46,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-01-17",0,"F",2,NULL,"639");'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 59</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(47,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-01-17",0,"F",2,NULL,"501");'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 60</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(48,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-01-17",0,"F",2,NULL,"068");'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 61</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(49,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-01-17",0,"F",2,NULL,"076");'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 62</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(50,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-01-17",0,"F",2,NULL,"596");'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 63</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(51,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-01-17",0,"F",2,NULL,"867");'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 64</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(52,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-01-17",0,"F",2,NULL,"505");'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 65</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(53,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-01-17",0,"F",2,NULL,"407");'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 66</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(54,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-01-17",0,"M",2,NULL,"105");'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 67</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(55,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-01-17",0,"M",2,NULL,"501");'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 68</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(56,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-01-17",0,"M",2,NULL,"131");'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 69</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(57,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-01-17",0,"M",2,NULL,"296");'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 70</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(58,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-01-17",0,"M",2,NULL,"231");'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 71</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(59,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-01-17",0,"M",2,NULL,"851");'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 72</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(60,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-01-17",0,"M",2,NULL,"668");'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 73</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(61,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-01-17",0,"M",2,NULL,"546");'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 74</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(62,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-01-17",0,"M",2,NULL,"868");'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 75</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(63,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-01-17",0,"M",2,NULL,"366");'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 76</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(64,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-01-17",0,"M",2,NULL,"844");'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 77</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(65,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-01-17",0,"M",2,NULL,"545");'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 78</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(66,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-01-17",0,"M",2,NULL,"379");'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 79</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(67,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-01-17",0,"M",2,NULL,"918");'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 80</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(68,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-01-30",0,"F",2,NULL,"826");'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 81</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(69,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-02-26",0,"F",2,NULL,NULL);'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 82</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(70,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-02-26",0,"F",2,NULL,NULL);'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 83</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(71,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-02-26",0,"F",2,NULL,NULL);'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 84</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(72,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-02-26",0,"F",2,NULL,NULL);'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 85</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(73,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-02-26",0,"F",2,NULL,NULL);'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 86</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(74,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-02-26",0,"F",2,NULL,NULL);'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 87</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(75,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-02-26",0,"F",2,NULL,NULL);'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 88</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(76,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-02-26",0,"F",2,NULL,NULL);'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 89</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(77,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-02-26",0,"F",2,NULL,NULL);'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 90</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(78,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-02-26",0,"M",2,NULL,NULL);'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 91</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(79,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-02-26",0,"M",2,NULL,NULL);'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 92</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(80,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-02-26",0,"M",2,NULL,NULL);'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 93</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(81,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-02-26",0,"M",2,NULL,NULL);'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 94</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(82,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-02-26",0,"M",2,NULL,NULL);'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 95</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(83,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-02-26",0,"M",2,NULL,NULL);'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 96</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(84,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-02-26",0,"M",2,NULL,NULL);'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 97</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(85,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-02-26",0,"M",2,NULL,NULL);'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 98</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(86,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-02-26",0,"M",2,NULL,NULL);'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 99</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(87,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-02-26",0,"M",2,NULL,NULL);'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>100</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(88,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-02-26",0,"M",2,NULL,NULL);'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>101</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(89,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-02-26",0,"M",2,NULL,NULL);'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>102</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(90,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-02-26",0,"M",2,NULL,NULL);'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>103</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(91,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-03-06",0,"",2,NULL,NULL);'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>104</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(92,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-03-06",0,"",2,NULL,NULL);'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>105</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(93,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-03-06",0,"",2,NULL,NULL);'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>106</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(94,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-03-06",0,"",2,NULL,NULL);'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>107</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(95,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-03-06",0,"",2,NULL,NULL);'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>108</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(96,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-03-06",0,"",2,NULL,NULL);'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>109</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(97,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-03-06",0,"",2,NULL,NULL);'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>110</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(98,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-03-06",0,"",2,NULL,NULL);'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>111</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Mouse" VALUES(99,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","2012-03-06",0,"",2,NULL,NULL);'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>112</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'CREATE TABLE Experiment ( 	ID INTEGER PRIMARY KEY, 	ColonyID INTEGER NOT NULL REFERENCES Colony(ID), 	Created DATETIME DEFAULT CURRENT_TIMESTAMP, 	Modified DATETIME DEFAULT CURRENT_TIMESTAMP, 	Name TEXT NOT NULL, 	Priority INTEGER, 	UNIQUE(ColonyID, Name) );'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>113</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Experiment" VALUES(1,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","Alpha",NULL);'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>114</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "Experiment" VALUES(2,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","Beta",NULL);'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>115</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'CREATE TABLE ExperimentControlGroup ( 	ID INTEGER PRIMARY KEY, 	ExperimentID INTEGER NOT NULL REFERENCES Experiment(ID), 	Created DATETIME DEFAULT CURRENT_TIMESTAMP, 	Modified DATETIME DEFAULT CURRENT_TIMESTAMP, 	Name TEXT NOT NULL, 	GenotypeID INTEGER REFERENCES Genotype(ID), 	MouseQuantity INTEGER NOT NULL DEFAULT 1, 	AgeDaysUpperLimit INTEGER, 	AgeDaysLowerLimit INTEGER,     Gender TEXT, 	UNIQUE(ExperimentID,Name) );'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>116</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "ExperimentControlGroup" VALUES(1,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","Phi",NULL,1,NULL,NULL,NULL);'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>117</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "ExperimentControlGroup" VALUES(2,1,"2012-03-11 23:47:27","2012-03-11 23:47:27","Gamma",1,1,NULL,NULL,"M");'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>118</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "ExperimentControlGroup" VALUES(3,2,"2012-03-11 23:47:27","2012-03-11 23:47:27","Omega",NULL,1,NULL,NULL,NULL);'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>119</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'INSERT INTO "ExperimentControlGroup" VALUES(4,2,"2012-03-11 23:47:27","2012-03-11 23:47:27","Delta",NULL,1,NULL,NULL,NULL);'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>120</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'CREATE TABLE ExperimentCandidates ( 	ID INTEGER PRIMARY KEY, 	ExperimentControlGroupID INTEGER NOT NULL REFERENCES ExperimentControlGroup(ID), 	Created DATETIME DEFAULT CURRENT_TIMESTAMP, 	Modified DATETIME DEFAULT CURRENT_TIMESTAMP, 	MouseID INTEGER NOT NULL REFERENCES Mouse(ID) );'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>121</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'CREATE TABLE ExperimentAssignment ( 	ID INTEGER PRIMARY KEY, 	ExperimentControlGroupID INTEGER NOT NULL REFERENCES ExperimentControlGroup(ID), 	Created DATETIME DEFAULT CURRENT_TIMESTAMP, 	Modified DATETIME DEFAULT CURRENT_TIMESTAMP, 	MouseID INTEGER NOT NULL REFERENCES Mouse(ID), 	CheckDate DATETIME NOT NULL );'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>122</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'CREATE TABLE AppState ( 	ID INTEGER PRIMARY KEY, 	Created DATETIME DEFAULT CURRENT_TIMESTAMP, 	URL VARCHAR NOT NULL );'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>123</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'CREATE TRIGGER Colony_Modified AFTER UPDATE ON Colony BEGIN UPDATE Colony SET Modified = datetime("now") WHERE ID = NEW.ID; END;'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>124</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'CREATE TRIGGER Genotype_Modified AFTER UPDATE ON Genotype BEGIN UPDATE Genotype SET Modified = datetime("now") WHERE ID = NEW.ID; END;'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>125</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'CREATE TRIGGER Mouse_Modified AFTER UPDATE ON Mouse BEGIN UPDATE Mouse SET Modified = datetime("now") WHERE ID = NEW.ID; END;'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>126</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'CREATE TRIGGER Experiment_Modified AFTER UPDATE ON Experiment BEGIN UPDATE Experiment SET Modified = datetime("now") WHERE ID = NEW.ID; END;'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>127</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'CREATE TRIGGER ExperimentControlGroup_Modified AFTER UPDATE ON ExperimentControlGroup BEGIN UPDATE ExperimentControlGroup SET Modified = datetime("now") WHERE ID = NEW.ID; END;'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>128</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'CREATE TRIGGER ExperimentCandidates_Modified AFTER UPDATE ON ExperimentCandidates BEGIN UPDATE ExperimentCandidates SET Modified = datetime("now") WHERE ID = NEW.ID; END;'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>129</span> </span><span class="NAME">agr.sql.init.push</span><span class="PUNC">(</span><span class="STRN">'CREATE TRIGGER ExperimentAssignment_Modified AFTER UPDATE ON ExperimentAssignment BEGIN UPDATE ExperimentAssignment SET Modified = datetime("now") WHERE ID = NEW.ID; END;'</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>130</span> </span></pre></body></html>